SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS OFF
GO

/*
----------------------------------------------------------------------------------------------------

-- Created By:  ()
-- Purpose: Select records from the Contact table through an index
----------------------------------------------------------------------------------------------------
*/


CREATE PROCEDURE dbo.Contact_GetById
(

	@Id int   
)
AS


				SELECT
					[Id],
					[FullName],
					[Email],
					[Phone],
					[Description],
					[ContactType],
					[CreatedDate],
					[UpdatedDate],
					[CreatedUser],
					[UpdatedUser]
				FROM
					[dbo].[Contact]
				WHERE
					[Id] = @Id
				SELECT @@ROWCOUNT
					
			

GO
